SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 602210 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 602210 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (661614,176007,194799,41708,710610,257644,59103,212383,226788,1003217,42949,114385,175883,907472,875114,1040293,342983,430546,923764,509792,57531,956342,231931,980104,130509,882595,392134,701122,1044118,951244,61076,850115,569678,862437,429305,1016792,785746,868286,611960,281644,532628,253650,667912,383050,895807,53213,232729,1033457,224520,731258,987990,370499,544418,539642,290822,722472,530667,205856,897667,415305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 602210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 602210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]