SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490354 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490354 [ RunTime:0.002000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037904,702408,188874,658525,430051,28697,503315,252711,1018643,985722,400500,941618,33614,138910,584429,945496,831774,273791,265318,477745,1002223,654287,353434,1047274,345148,567736,538103,300600,21690,160462,775909,116857,210792,665254,626160,855994,560102,691526,580386,713181,554950,796621,839404,2158,501331,834637,865277,868464,116192,178975,883838,1030556,704189,360880,500136,345941,510117,1007834,966044,978623) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]