SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419014 LIMIT 1 [ RunTime:0.001607s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419014 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (557613,687031,358537,216190,763215,84406,41733,849564,119377,245320,522651,744914,936079,956002,297165,918369,835837,105124,58994,250613,292622,277437,211586,78384,417748,288002,55751,998164,41792,417410,795957,585956,706909,11451,904941,940992,621602,851060,1018832,850616,470154,87630,360009,963809,353708,963723,362760,354620,310561,735994,318701,479115,129237,906517,672678,366756,840950,359241,557366,360167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]