SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 963983 LIMIT 1 [ RunTime:0.000689s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 963983 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413269,385573,243472,484863,548485,977173,510046,1003095,60033,638869,512461,1035949,476931,665235,920379,419078,475178,600556,570351,528388,605395,608778,1019335,989253,673967,296978,645445,632037,417673,617583,330230,1043958,190925,74554,816624,822767,224137,534491,266502,549835,3180,579061,1029121,592658,86571,279649,662716,723672,591826,428491,372117,199503,590835,239396,665734,975545,133242,970336,339897,900268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 963983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 963983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]