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` = 564051 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564051 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008181,796497,398996,917276,464814,199802,700458,705920,693207,605564,792870,560021,710577,485214,670656,155611,892133,201528,698383,658021,557169,804409,748478,493329,917142,659590,404662,583717,109371,381518,925629,843978,772498,795570,431287,829476,372176,258159,91956,230656,13777,213494,429192,506835,947280,271190,33013,351709,280089,515919,231494,538807,328337,723073,871596,952433,465188,12011,653965,154056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]