SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451743 LIMIT 1 [ RunTime:0.000578s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451743 [ RunTime:0.006506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288667,783667,126126,687276,173861,921141,963651,900072,673454,841022,948265,709103,24318,769485,138226,299790,385508,530674,885635,998356,604943,945802,750107,900813,246035,682969,994697,431708,211310,477898,939462,408996,572529,780919,507923,369629,693564,6358,310618,698006,536522,294359,986959,764174,494624,421397,186577,1032604,577284,61522,464393,470297,959068,705662,668352,781471,23677,635349,761331,692294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001081s ]