SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002746s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106063 LIMIT 1 [ RunTime:0.000479s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106063 [ RunTime:0.001998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (255256,940502,762514,282498,715445,615314,656393,463192,1010252,297905,303825,113679,963350,394870,141800,21940,1025807,958954,749074,455556,1022836,244328,915517,823900,305998,1039461,386553,959556,798867,812703,200259,975377,289331,170061,758337,136195,539466,548853,237759,606850,415728,717519,404584,678225,207332,987840,622307,153017,58557,583093,606785,163088,689828,357320,46649,484247,644443,104321,938658,1001608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001109s ]