SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 606425 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 606425 [ RunTime:0.002792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409371,1034068,604063,878523,610096,701200,517367,51580,787164,850140,489810,536046,423821,717959,385293,1035433,358271,885869,970214,104377,964499,12927,586200,769695,555481,193829,600379,74723,881261,367837,40115,178561,384498,1033276,561273,299623,48655,615400,729081,486781,977144,781233,759740,695299,235525,117764,558053,102066,928694,151007,891094,156100,144824,260345,716473,563813,914210,287838,846309,663154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 606425 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 606425 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004461s ]