SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503183 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503183 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190825,366825,760874,16135,714803,514818,781415,596561,256080,626562,336389,681523,921898,1028533,83029,124633,138117,352922,753345,577781,64971,190449,1009892,96420,521704,608804,849364,292844,1001721,1011644,1038801,830658,97934,672931,862940,184630,1306,487169,928881,844279,7986,907354,1039352,632579,39693,596263,872655,886894,139045,220295,596924,262338,1030889,404465,424091,169641,964667,1019187,961399,891734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]