SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 324679 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 324679 [ RunTime:0.002074s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (93827,135123,929827,50448,759441,541240,794007,469495,118046,288553,151317,524653,484453,471943,185104,63176,140018,283850,790221,363202,598505,1012644,801698,119889,334381,192118,495834,528569,341023,752613,777811,923379,415797,101533,697767,946406,820705,1002503,696484,194312,459861,945458,737604,363044,795337,58998,921985,921647,123047,205272,774285,555475,609829,564431,295190,311702,569764,1010402,325182,543963) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 324679 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 324679 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]