SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045483 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045483 [ RunTime:0.002741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146768,423662,684235,106187,190536,985587,70508,806266,263831,650737,950066,145703,753476,543977,60588,161551,728201,260653,77656,39486,760487,231100,576854,943949,638529,182446,901124,879829,46972,876115,479236,93565,287469,572710,466800,175724,916713,66322,807127,882581,452150,537118,593569,431024,154204,429621,206138,313321,356628,853211,994166,359914,265846,817428,566136,322612,775117,810636,307097,135445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]