SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502103 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502103 [ RunTime:0.002038s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229497,237965,154730,977609,520821,1021849,412358,236206,662570,280251,252259,213978,280168,134895,248251,447931,127430,443671,647764,709256,630248,749507,580384,779392,56953,934454,919319,473423,595429,257861,652676,487123,221271,462082,97359,264221,859602,673014,389329,435749,57341,755592,974446,611014,707800,52493,469332,780741,367531,977441,268071,583073,19399,650199,791149,803564,807501,759260,93989,439537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001815s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000782s ]