SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444039 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444039 [ RunTime:0.003482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820814,26970,129825,606568,1001996,345874,835287,567740,582255,248659,269769,963198,186663,947961,428131,603457,860295,1002827,529356,264856,779108,788675,491376,468171,281482,118439,368812,936948,343366,138912,1043676,290166,635976,64727,446595,508954,248678,917124,173937,635776,177304,840706,163486,499811,613384,926143,677999,334675,901337,277230,74795,341470,386867,495997,999652,223104,850616,682013,848683,817330) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000963s ]