SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001866s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423760 LIMIT 1 [ RunTime:0.000879s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423760 [ RunTime:0.002160s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (832042,452893,171238,447030,32797,418614,518743,499384,1024093,922426,852093,936869,791013,520956,134861,332160,169575,913680,1046099,886387,898310,901342,501216,120203,955381,746698,673650,314982,183297,321570,275309,304195,366941,893353,718408,460630,202184,601404,989058,67808,685809,596337,582272,1024745,797329,1028815,820721,822027,223883,123063,993342,359518,956536,538626,345065,1028472,350832,925690,682536,12847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000757s ]