SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 9190 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 9190 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502670,950407,787789,846254,533913,508642,711900,959776,612772,145980,1028032,1025050,1042359,477138,1022061,13946,40725,123966,530961,644213,267136,754355,1045866,390661,1002922,59292,260155,431606,673786,361500,544221,808737,390158,759755,996800,19427,201868,345353,491833,433148,725899,814806,944797,670548,765196,961266,257871,686472,371522,974132,804504,189226,187324,978699,592628,855920,173321,555602,412768,805275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 9190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 9190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]