SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293823 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293823 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047022,818035,195077,999958,772200,960860,1046932,1039217,721363,108397,967509,387812,836894,382482,138590,541809,628115,526015,113668,509666,895826,179900,808063,263669,582257,705879,846955,428240,719048,84383,148141,963176,599420,574845,289538,931079,1019036,443101,101650,604518,458073,495791,301241,707405,8156,997591,589818,1031346,783836,490704,389791,951354,656476,936561,507936,740110,863170,485833,395493,494736) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]