SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580020 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580020 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (747549,334984,73687,555489,245890,302771,1025217,249442,444,745856,298578,410243,700970,846393,1046928,872622,717169,622146,881781,1004971,298671,149394,357894,429915,471799,694072,95905,500704,1025944,181646,958002,991692,358791,679454,644151,192537,133853,13847,107255,944361,268439,1010371,48196,978915,897023,16211,687007,130971,692923,914028,654727,999188,729682,746839,967542,277365,209825,789826,743862,727153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]