SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477643 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477643 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529151,610229,646103,127742,504481,271861,303881,909062,801159,755603,697745,92806,1046184,619612,269372,938531,265158,331283,942072,198855,774311,91906,1024231,498747,34607,774187,242578,178894,309977,496836,178761,622539,173922,1020770,801426,637172,594109,844980,943535,534764,1047802,66114,288989,424764,618405,948036,724747,724088,580714,388238,115671,101253,260241,265871,148631,75890,600788,961596,346642,406652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001624s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000999s ]