SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50018 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50018 [ RunTime:0.001926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715134,828275,424780,200098,272426,571852,277110,372948,848215,337248,563746,334176,58551,646738,648846,537614,182533,624547,860176,939608,582190,816811,931831,580678,780112,280054,468826,487151,686012,837899,592391,138687,633170,640562,131012,475928,798468,1040427,839781,658475,531892,538886,75826,481071,563983,494991,432834,392713,142156,242961,251403,198169,221623,569700,130751,184966,645955,46251,532036,266381) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]