SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042491 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042491 [ RunTime:0.005479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044804,185727,642542,452512,915711,552774,65241,11230,358333,106991,709657,943409,465661,261792,510146,164905,268204,315157,482891,621528,955710,413789,800209,349287,1007270,411578,283309,308043,917764,8241,786309,768212,1024525,818162,941214,3330,723173,859583,864564,96794,26004,823692,315352,682740,370079,639119,454408,970214,1001292,14520,664878,446750,632663,382493,141789,560761,977224,345372,443457,411350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001718s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]