SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413532 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413532 [ RunTime:0.002930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587094,288593,989364,441375,480630,206244,288021,904377,372796,1029707,133191,500730,235430,775751,776136,600760,34002,1017873,950465,93463,402555,651193,707262,877951,314019,308829,499997,157140,1042182,195839,750136,380907,956136,196581,842615,791926,642487,34127,846527,749252,834581,623844,28540,591462,548013,76029,614587,232788,945692,900008,474991,865157,385168,270742,449955,628965,950929,190653,205652,644540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413532 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000645s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413532 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]