SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509441 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509441 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031257,1045773,640231,1006976,919304,618443,436495,57342,853518,367907,654554,836297,635141,166395,409786,403278,365403,855528,985818,797901,1045820,506912,27288,738377,394668,436719,702502,953888,45092,3619,454988,294855,268607,885176,797821,976163,898805,51743,499890,204211,798096,756795,1023572,752205,863607,698844,281102,924280,903234,549,699324,787700,958938,38435,872194,53409,863787,943459,214692,101652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]