SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002056s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511181 LIMIT 1 [ RunTime:0.002877s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511181 [ RunTime:0.001853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (667086,745508,746426,883071,913955,181669,329402,652081,223231,184781,878721,735733,277587,265960,931899,515935,10378,311551,1009669,262969,574188,108117,440312,217247,887892,857486,874311,648127,999893,1042374,907420,171496,617715,728637,167769,245231,441525,242972,445319,1464,352490,299098,620894,439122,652695,1014552,236771,483489,438232,689862,1029780,888427,670774,44432,578490,351981,723109,626571,284494,444174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]