SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019411 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019411 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3787,1018822,577443,599696,942319,286450,932571,612631,314858,314026,325110,821658,734467,31233,552091,978442,833799,663881,1036873,215023,633908,199376,337586,504653,408385,789450,911905,211568,162855,553798,312384,1028451,577949,992221,240280,678894,35704,497102,798689,746577,323985,1015936,437186,1014667,1046583,453399,980700,391759,18695,777799,264751,335436,155339,94311,340144,294687,398828,104605,725195,121585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]