SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001415s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550499 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550499 [ RunTime:0.002512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69261,418406,305119,138213,847208,781151,407301,284945,820012,94029,1011321,1015999,876479,570411,835177,848985,736769,95435,47716,719964,803977,778107,437927,557713,14106,969878,619328,955408,232920,96458,1046712,1010921,617409,484734,376716,1006454,493427,759615,725984,945,542181,201840,13198,234172,683120,623035,350373,412353,192426,135435,326649,760953,475020,884815,444609,135951,434400,794277,331624,119448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]