SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331980 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331980 [ RunTime:0.002287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (928980,45537,283267,122989,146828,544676,753824,606021,480325,713778,880711,366356,518938,32095,50390,365655,103204,75213,300194,353245,392630,233531,839155,783607,103235,1048531,232200,264850,531217,617676,754564,303040,549553,184738,493195,366425,521853,802497,583847,661279,5460,411921,996632,121836,639654,604337,595530,826753,936875,683222,807817,646170,491591,703163,715147,715525,627184,78062,680155,458013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001038s ]