SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547692 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547692 [ RunTime:0.003011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118768,364759,326138,212867,15273,570110,141490,305215,602703,269769,299330,936790,305347,976458,533171,129024,766529,678560,886970,742386,464042,884707,251579,634547,848277,244987,722072,1003880,296041,985587,443275,764072,97551,538859,550041,584017,1008574,160550,403061,244535,1003701,879603,938102,299553,121589,827579,61750,557402,386666,941165,351951,960651,770918,1035093,689028,379442,470985,955687,741855,205645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547692 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547692 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]