SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101966 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101966 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (827016,407893,600957,46452,981287,118433,145734,560206,852275,915465,533385,11545,944900,487518,663522,484807,455160,806813,519944,277925,582228,495500,712929,617545,56699,678567,798402,793076,985589,234088,777496,450307,672155,82283,5638,486514,1033191,820018,359215,325813,487029,439801,297232,139031,745478,274211,461504,323319,449081,763732,852325,236924,204758,160652,573583,337801,763382,223026,545184,725944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001704s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101966 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101966 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]