SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514653 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514653 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584494,392285,678039,961987,258363,877697,756167,111986,942558,276122,663744,1010915,590632,458751,250084,424017,664291,476605,31165,995506,234916,293974,299485,502137,838591,446767,490174,647369,474561,881645,277643,435127,652805,320740,92267,244759,286012,825959,549463,641701,434019,593325,333466,1003420,59979,244780,988333,831799,419059,541595,874501,354692,776648,898632,110400,579087,754363,135554,768760,517087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001014s ]