SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200474 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200474 [ RunTime:0.001557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617190,308467,547546,250844,572869,496139,446380,925331,256730,724617,915866,548692,523645,981021,653663,99271,859817,287516,95699,836193,133472,1022761,427773,962689,827421,789294,384858,206528,170841,348261,417593,655361,151168,337067,488109,96595,601251,1046434,551137,942164,779497,40500,28028,778166,501595,949698,825551,182303,562299,376344,626997,549729,758674,734223,260873,1027413,329398,977925,500755,665515) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]