SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402400 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402400 [ RunTime:0.002181s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (99000,75863,462755,136624,360833,423493,481253,216085,390176,642690,11276,1035280,514786,540255,889613,1031290,977968,358030,802319,793667,677365,697121,689418,487346,238081,940123,457242,332072,589418,399935,490452,800846,681146,740470,285060,119155,688653,546720,543820,686191,193021,153561,969545,809316,710653,1042108,938278,196528,178230,982063,293656,875011,544393,66449,363605,907045,568358,508199,375432,892577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]