SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539416 LIMIT 1 [ RunTime:0.004270s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539416 [ RunTime:0.003344s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (901810,365756,86669,539386,856096,753252,1009691,732775,913256,595449,802379,511767,434199,42569,330951,93528,94038,337693,924162,717881,584457,512943,197027,721782,162491,661217,46674,278721,575978,841487,131508,275958,733391,635186,758097,1034409,377872,668671,942088,779886,327276,606704,44105,635341,932119,190253,1033872,28519,826284,1024009,286376,476085,62322,329651,839160,48190,323981,601843,482617,946488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]