SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426243 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426243 [ RunTime:0.001485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278377,264119,235705,301743,114881,1020536,598369,868675,901369,391055,245255,116348,60441,686739,642822,515012,764315,157059,343708,648263,833160,423456,250563,139393,235339,797645,1018393,161273,696046,447744,114651,681816,823124,858551,654992,1026453,709304,181276,526565,673078,1045847,193505,436993,941214,548903,190935,867422,614176,198738,712724,1037387,730603,694728,996679,280020,446991,627443,322898,979578,84855) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]