SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001528s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 817686 LIMIT 1 [ RunTime:0.000583s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 817686 [ RunTime:0.002211s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629838,152884,188917,33588,580031,381479,1039411,73030,200808,647134,718799,658622,739041,770377,307991,454333,861916,441456,159417,357680,100265,972840,454933,919998,720920,605231,45761,927247,316087,300173,146741,25867,134096,319959,664463,206900,884747,202638,841690,848921,741323,1027397,164461,926120,81315,190122,968141,631089,383193,308278,964617,670761,646171,506811,828365,216219,97661,744378,390589,603264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 817686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 817686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001201s ]