SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 321883 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 321883 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121336,74016,1022360,378709,365678,971212,506072,35559,173703,873505,503690,771989,476587,33115,393972,444835,986214,793111,582062,144655,190335,681492,235762,975370,26427,273251,470310,816221,256680,356982,211529,367558,768817,971944,395737,469212,746660,969727,1035166,829253,205823,657227,791416,270673,476371,981248,837047,437805,432032,774190,670992,102465,908925,1016264,795383,430487,446691,421052,957445,372403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 321883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 321883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]