SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 840281 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 840281 [ RunTime:0.001418s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221209,369242,49978,956615,50429,141354,174500,490511,385210,958158,794764,483008,861913,251457,390767,836788,367558,410950,439613,211791,844859,375130,234918,464533,175740,992547,840793,709482,369956,894149,72002,744233,844851,469376,937551,478011,548375,88172,906659,771681,234470,40352,623432,1032060,175785,208668,317540,187650,572760,520600,986278,619222,839962,932792,894843,546982,657797,72565,860931,251247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 840281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 840281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]