SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103512 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103512 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383726,782984,765024,420913,180918,647375,7629,728060,511573,973531,876813,346421,808117,670610,920301,852576,152031,28615,504319,343104,39037,542263,573873,264076,510512,744687,65066,830789,193949,885268,424931,767275,10313,1019793,950632,631172,164555,183154,825483,834111,106822,387438,707668,207224,535769,957528,713522,722766,990979,264895,50071,287630,59265,696021,886638,15114,382352,201032,158907,887332) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]