SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294551 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294551 [ RunTime:0.001908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371099,385113,885870,711098,53450,953037,540754,229442,658105,111294,605244,146836,451581,566254,412494,489638,728636,887127,703396,307612,170716,454370,438638,145457,876231,697507,236451,952274,371006,238766,698747,798264,905210,317232,808949,393688,494323,223757,730302,639880,317974,181661,174765,50209,924307,7540,993792,48482,335491,952891,524115,641764,163006,366211,190171,282275,271785,178651,606810,1001399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]