SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419864 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419864 [ RunTime:0.001431s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (919381,895782,220643,315282,413548,272255,1014581,646416,305869,421046,201836,594864,711093,695877,738941,766078,961148,734914,1043707,833723,390999,869850,550906,343315,455080,50953,968202,699576,1019673,35823,569372,367329,741755,677232,566724,645225,230289,805202,328424,255703,434647,773473,913095,1042254,149221,229475,428954,146008,753717,144282,566592,307239,963930,797217,878619,492965,320882,713450,567986,66088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]