SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477075 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477075 [ RunTime:0.001785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (772377,961515,1010584,650524,425977,463938,219038,2418,493740,859398,357051,671241,485157,90221,48165,15918,202353,554047,1011752,862375,1013007,311980,20357,103495,818888,1006418,493234,980600,848733,379689,760148,212518,601363,251317,136984,523841,711843,624187,88801,282125,896208,925968,778441,550600,877609,468103,42877,755329,429042,477475,300614,666555,121487,765641,468035,568960,146503,354983,376059,951575) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]