SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559084 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559084 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802045,728716,1018694,327601,1022499,1045279,841521,664071,93812,257071,933835,896411,1029619,19605,660498,311091,812908,1001599,736369,1040967,66924,598306,572637,700077,879812,632890,662094,495605,705523,378499,550327,209420,139586,1020344,231683,782377,252293,840807,420426,445600,257920,706860,459253,189808,597695,242333,477267,501461,702442,378819,925452,522185,854283,764379,259764,774445,847546,159693,563794,900911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]