SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399598 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399598 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (946804,361087,901108,52489,366296,283210,256619,503655,452196,872686,710519,829414,178104,887380,947223,451723,253504,387078,237814,265668,655754,488994,383108,379280,9718,535559,850555,58722,402375,708601,959152,62734,13290,859835,886500,493833,436121,665637,145678,63152,302687,635206,396688,703424,973371,965493,608569,578042,993081,636351,940798,459570,575837,363506,61496,864362,367139,931697,392621,136315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399598 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399598 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]