SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474583 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474583 [ RunTime:0.006907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329893,505313,1018144,647127,821505,469475,730201,570756,968892,901629,541640,593038,188657,281,435970,203633,494009,337613,734837,1008669,49934,648558,327671,1042393,669472,374348,594014,1019405,407900,995573,614360,670565,897810,37091,693502,241349,606563,849495,1003885,312351,999638,890798,268786,821791,757959,896014,504604,812431,429717,912686,242917,404744,774571,865614,368974,463779,737551,892109,893939,638613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000777s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]