SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000927s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512510 LIMIT 1 [ RunTime:0.000557s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512510 [ RunTime:0.002318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (630749,569183,336067,886103,549269,1009882,938439,712228,505511,114710,662836,5420,905535,753763,647253,269529,738060,192211,497567,380452,996895,144235,999128,528989,514904,857822,730387,146180,915795,348022,211541,577307,143861,462725,981413,823352,787900,497009,432412,1020441,606274,1016714,337317,131167,347945,830464,285149,796189,619860,312437,991215,320429,441596,312128,597082,880216,499606,491761,1024538,867427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000764s ]