SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001747s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503752 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503752 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583233,103766,667034,451366,1047184,625469,109803,773938,816195,756783,534444,920028,1034443,201737,26200,209723,364874,375559,989427,818929,424954,379443,715688,52885,728995,157533,191322,265377,810290,780927,762710,732263,21923,398967,625911,110418,474585,164146,1005137,815626,213205,276553,698222,844168,112458,24700,36023,711076,403626,99497,715595,305582,201704,199036,98077,581338,435216,822768,870265,189659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503752 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503752 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]