SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532600 LIMIT 1 [ RunTime:0.002474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532600 [ RunTime:0.018801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614920,206332,4547,808841,1010210,991625,401445,469568,905789,926014,892924,323081,790968,1010865,36978,696063,229436,275407,760157,753795,520000,923510,289124,965701,142582,731480,982722,895259,899971,940976,83986,899944,317705,344673,628637,1019594,48643,83261,760611,635141,389395,245079,705643,803225,169471,499245,946379,498790,409552,864994,17428,548684,422816,311536,343809,676879,904068,366769,629717,526602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532600 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532600 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]