SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557284 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557284 [ RunTime:0.001377s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809673,901803,664342,763855,232194,32768,642324,743074,154422,285815,52276,809112,111473,395971,168719,190625,826380,780944,622498,564331,104654,1027718,688105,32948,447369,489990,507896,725336,557536,615771,136763,734624,169083,197007,945272,765249,270926,631293,302123,961662,1001818,977519,435596,64348,740851,274428,481905,561261,979991,375215,81327,127535,485600,190003,843074,484410,345611,129594,207447,703505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000378s ]