SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803431 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803431 [ RunTime:0.002042s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516413,187438,528207,554242,965074,152575,578424,120681,981861,303272,146289,630531,1026223,55201,644208,829390,504775,906404,1040410,154430,777147,760210,542787,17761,259178,841139,493228,61692,910711,664281,49119,954093,485580,800719,821324,712749,714561,641734,173178,566173,488530,36686,307545,738345,868488,828807,672009,551491,60013,712844,413137,779654,445525,626560,203443,474738,231007,11518,700806,379358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000369s ]