SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020360 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020360 [ RunTime:0.002479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596300,956530,145975,349755,246474,290177,89358,297191,568131,928935,223671,682294,1048555,541948,647320,614147,562656,895105,373748,99025,801416,460719,836253,558936,529602,213381,397202,797932,53525,103816,1006941,617729,57581,704305,185500,398317,434311,214092,977009,715345,989345,950377,701048,670097,189918,643070,700011,559569,312823,269816,698142,163371,963539,324027,785078,942340,1030645,993720,805253,221156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020360 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020360 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]