SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503010 LIMIT 1 [ RunTime:0.001004s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503010 [ RunTime:0.003476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (175901,597610,617718,344235,421262,368059,475856,403681,1009029,245881,373782,461250,675251,383686,13601,18398,289486,309462,561355,101750,13960,582279,396896,488986,798465,473111,116019,1039053,918652,370588,882445,991528,684490,528200,141612,688627,194573,868263,556155,176474,614264,471271,833737,1037333,1012359,87977,827717,676437,865510,563383,310720,36568,263899,843723,581509,999196,635083,288362,487967,628388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000821s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000840s ]