SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802980 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802980 [ RunTime:0.002890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (879314,388230,340791,245691,977979,1031843,103491,101723,359068,1035436,126925,556898,302351,12308,917366,403614,915795,424718,839718,558563,517824,391462,980386,131139,681569,390093,229991,328360,970774,918750,17025,815677,1018875,609809,815763,242295,635954,1037685,540255,260868,319453,800307,522126,87907,60909,705334,179276,869872,290471,634205,916457,159795,286592,1032962,52945,263044,110111,789792,567253,256920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002956s ]