SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580680 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580680 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (494040,628164,133599,720537,5855,43138,968534,31613,696892,210448,929232,672250,498866,498189,667442,239464,771691,670304,590868,108013,1042377,649122,657764,237365,630496,774547,900160,887070,908451,333822,971292,407358,978987,738715,359262,570485,618054,133264,300440,994757,966623,535175,47465,23952,548496,93141,418631,82371,1015274,971671,833717,346754,514181,163979,856234,189888,846021,724630,486053,1020717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]