SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001620s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101881 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101881 [ RunTime:0.002080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596560,980467,567418,336358,828382,96581,130521,890426,433873,74698,779217,540598,725058,950868,204499,721078,887743,1003138,214434,643796,866397,214503,765206,875146,774953,426499,446779,622993,158859,484576,560962,20240,724141,149246,810428,108243,345292,717422,183606,921766,56058,827098,1028980,276127,5077,878123,697331,947207,108403,549335,1040569,424238,783679,930169,40994,473966,702359,286189,632978,592970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001577s ]