SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502339 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502339 [ RunTime:0.007376s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308662,992811,94179,998333,804102,488392,669474,537773,396155,602965,115744,840422,446526,654238,432322,46222,682740,912072,691324,799953,638888,824176,578451,525935,45848,523649,206394,453786,826940,139256,279581,487919,181210,386066,11543,758006,838464,1000396,767367,43352,1011375,258854,550898,275806,412022,354907,313788,994186,164182,747403,990533,895145,121837,589771,314049,979153,642652,436845,718444,841824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502339 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000657s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502339 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]