SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102894 LIMIT 1 [ RunTime:0.000687s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102894 [ RunTime:0.003839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (869778,296672,943473,374730,383951,315480,712834,357288,181856,116005,32802,990007,969655,626641,709894,669271,917825,726739,430052,43531,896625,874974,587556,151153,260259,1014892,84771,459905,940789,895134,101875,345971,406453,546879,771862,646960,1021660,366929,820866,791583,948724,488616,247995,686261,133725,54629,117605,75221,86887,26209,65896,159490,162121,354100,965820,883852,260360,55805,662885,565036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]