SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465266 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465266 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408711,348647,918291,326406,967040,159002,829697,709337,340162,781488,961069,227941,912112,635601,432510,299871,674123,951318,463097,453536,906612,596403,295441,950167,926255,420627,46892,616250,605784,604062,85880,815912,926804,491123,4099,567149,828621,979280,703231,461934,134058,723079,705179,915065,382927,768387,117370,8638,389297,519391,29951,78030,4902,947704,64024,687559,186555,575857,465543,690230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000914s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465266 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465266 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003918s ]