SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006921s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018506 LIMIT 1 [ RunTime:0.004339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018506 [ RunTime:0.004407s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936987,315645,42901,1017188,937315,698591,665510,127174,391825,241921,125505,22329,185268,934553,240098,274303,274205,1019522,410931,139954,515482,857909,500191,287751,465743,593992,132307,782151,882526,52787,276197,391518,828085,123708,777110,73186,285996,157160,890711,214109,765440,537407,1793,538463,27246,481063,50385,834491,538014,994482,1026292,689100,206505,542883,522165,671031,335876,720181,81304,776190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000917s ]