SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003503s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320815 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320815 [ RunTime:0.005846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530104,68060,217823,639930,909747,833194,1002589,585399,30332,325537,839700,435121,782518,193991,389601,213086,20773,808702,574263,549842,2793,232423,196556,25178,191264,317261,702812,755112,814579,641256,948017,1006230,173546,193926,172406,694360,625807,805907,144036,394742,30860,725120,934082,10666,784567,453250,460749,645909,195894,1033671,887746,992993,320190,135802,83376,34771,1038602,71784,182635,984167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005840s ]