SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382670 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382670 [ RunTime:0.002046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194381,651893,798487,198022,235898,32262,975118,42150,570585,292538,812249,24714,101963,237431,865842,421380,37894,261779,73313,1035215,218496,753522,820454,1042916,1030070,1009859,427485,942958,573164,588788,906546,387494,451600,905764,293218,762624,315847,421650,751245,206333,502106,986369,626386,58055,578240,275559,804150,5250,715571,783948,5597,90137,621847,760171,870680,833545,907065,189470,530703,502470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]