SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 183093 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 183093 [ RunTime:0.003640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10431,626031,774179,970320,171105,924078,762312,925593,196788,1020874,880788,91384,21751,1020075,713760,611803,255670,1041177,151685,403681,19535,591177,838815,9631,172442,889927,932544,597283,779509,164176,176631,142469,338821,350594,156279,609365,16401,217078,133082,62769,541322,172949,479132,895723,753014,940694,313050,342862,433859,333848,84275,945526,591533,216800,828028,268841,768131,750537,499117,294022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 183093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 183093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]