SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802513 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802513 [ RunTime:0.002509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315656,224285,765066,721270,178664,369491,323806,247950,397577,262345,747940,1028756,293595,903306,537354,76196,61554,1028989,222904,383020,382858,455209,894902,316814,101371,1041969,905663,320379,203852,620751,90519,958905,518647,358712,277660,604007,988001,773897,599803,692436,502612,1005259,437002,666953,1000909,728114,835265,688385,1008953,459175,277450,400326,807359,281723,315684,684424,262238,909620,285186,473161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]