SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45353 LIMIT 1 [ RunTime:0.001486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45353 [ RunTime:0.002288s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457456,583642,856717,822010,925244,697073,403947,920598,632162,436786,1005566,543366,96780,1048814,968397,133560,787278,383240,584431,128131,738336,297551,659463,248726,903526,157102,534945,669902,78757,999173,45919,681485,355938,855710,333942,935729,941466,508137,494672,821547,819590,100948,315821,428491,605440,720130,973167,738348,455576,627583,443462,298949,827875,768394,984056,722994,386201,1007764,170364,140609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45353 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45353 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]