SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019464 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019464 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (908186,996239,257180,707305,291493,466572,943310,980186,631152,886134,100445,949953,99631,191368,87701,842959,872008,454644,326548,971800,715259,16097,279400,255393,147925,964600,99965,282038,956229,955239,211840,661767,467514,928587,374375,737928,689096,824553,512212,311123,635343,411671,1030009,579526,159478,238711,685984,194506,154148,809004,983158,248245,924870,524953,858557,389471,691375,77864,584446,13040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019464 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019464 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]