SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003011s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 327668 LIMIT 1 [ RunTime:0.002290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 327668 [ RunTime:0.009653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576725,126261,360314,515749,1033274,197311,302166,785752,977007,558124,907797,792281,690532,835992,926690,141021,776920,1028974,749138,88992,622629,255931,753329,759585,774735,441369,354160,551197,844111,822605,278115,449731,888774,54868,984041,445602,76089,1009326,587773,173484,736797,1035573,722159,142252,178171,947624,759612,458752,361417,743460,871542,382406,13062,471148,91700,542872,477096,904924,761977,1045568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 327668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002865s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 327668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]