SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020765 LIMIT 1 [ RunTime:0.000807s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020765 [ RunTime:0.004361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433216,208997,310643,986257,835869,519709,388985,727701,879871,510886,659910,1028767,128918,288263,584861,554883,43374,334480,86985,854807,343214,513817,626608,1033376,982782,627160,499202,216082,331456,754714,1028783,227597,349778,326640,805135,590593,627023,852326,803304,1008320,796134,1039977,450028,819883,676315,688660,199992,380128,166653,906801,388826,924732,771248,1029866,228927,650475,928898,489194,20894,278595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020765 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020765 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003018s ]