SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 649896 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 649896 [ RunTime:0.003603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818678,24543,801134,412134,743544,927505,493704,10112,494505,288722,280230,27816,891341,604829,396404,132765,771448,91711,167399,951688,395106,417052,1046034,695670,957400,768057,1021942,876894,948473,723652,551912,570626,688704,1035451,1041924,849987,1021848,788182,901789,900759,295827,158809,977699,936435,694278,141876,221031,383054,856185,894442,469755,557982,36556,67312,663215,298135,104529,561593,549015,346228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 649896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 649896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000698s ]