SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302618 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302618 [ RunTime:0.003373s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335138,559449,485646,540621,47868,319940,14155,675231,360549,837741,359246,206156,1003418,64824,305446,697959,775321,625080,190877,128455,417882,1023953,130880,533242,640639,727299,972853,792573,904701,567401,834462,367710,645661,688452,304635,720861,432153,1037011,551335,18149,643185,901806,707162,677176,627404,888864,446867,821678,422601,843567,508005,145084,877679,842025,643924,708595,938353,50443,325961,594647) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000994s ]