SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 446311 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 446311 [ RunTime:0.001944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (361077,259018,592452,870710,689971,660423,44975,48877,413018,830752,554404,526700,218904,1047384,395629,493135,861478,178402,326134,917382,101465,22608,323710,873732,686785,586182,997274,420379,687478,544938,189670,833221,1021359,562037,95293,77684,989994,184767,1010064,1034119,530802,399120,601285,405548,128520,800697,210066,689894,765202,400807,349491,103598,1024116,87745,852930,395859,947425,767978,775482,87687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 446311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 446311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]