SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001631s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508943 LIMIT 1 [ RunTime:0.001048s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508943 [ RunTime:0.003184s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190582,320486,20639,590367,539789,547171,311742,497822,997664,179622,517554,1031486,675535,988998,66055,218146,97674,196385,830087,264569,661645,698581,242224,23547,528700,364469,757001,809883,589500,395365,1037450,246826,280509,29692,965683,275637,458777,599961,273489,595584,503491,97891,33247,891468,1008982,804265,929330,338054,700578,247349,641509,614892,478159,348996,634409,871519,287161,362713,522604,284886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]