SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802552 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802552 [ RunTime:0.001521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (238929,471451,345276,742178,821291,425031,927246,303780,910657,537116,852032,331081,575763,300916,172498,846325,121662,545783,291731,647017,608593,85348,251275,169689,391723,725637,637228,423270,564822,250480,199964,112225,91297,120293,641797,987455,682776,933674,704681,928153,612805,537472,204789,642943,248970,601734,1011546,452697,687307,549169,1047158,1035864,2441,387999,151488,504951,728730,735714,1014030,239757) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802552 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802552 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]