SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320978 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320978 [ RunTime:0.003830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719201,64483,1004541,198737,1013567,476157,368409,412231,603063,837737,1040444,1043712,928867,107101,459536,868753,40563,1014801,719754,515610,200893,47261,1009201,152164,741285,871070,15877,872419,371227,781313,77243,886520,202297,1002604,782614,330549,503379,194522,633909,777890,107750,840578,1039275,158986,68248,795613,578189,203549,838951,483623,53764,940837,316055,408439,174619,991162,278937,722007,974461,383628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]