SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002526s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024182 LIMIT 1 [ RunTime:0.001213s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024182 [ RunTime:0.006795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400178,603905,261109,739310,902438,655338,572551,836468,332893,870281,440250,1035100,761801,395554,18725,343460,102395,604349,685829,640382,62592,908174,282588,470046,978691,807405,262207,508301,112343,995849,436411,1009434,53263,364112,588077,62797,947766,265870,528383,168025,1000689,1596,388538,207988,256914,897297,432112,924071,95598,788464,682081,1040413,710316,129228,680691,992565,136197,618254,156456,145846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024182 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024182 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]